In [1]:
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
from itertools import chain
import re
import os

import warnings
warnings.simplefilter(action='ignore')

pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)

from classifier import Classifier
from constants import *
In [2]:
csvs = sorted(os.listdir(INPUTS_PATH))
csvs
Out[2]:
['2014-final.xlsx - Sheet1.csv',
 '2015-final.xlsx - Sheet1.csv',
 '2016-final.xlsx - Total counts.csv',
 '2017-final.xlsx - 2017 LIS phytoplankton count.csv',
 '2018-Final Report Data.xlsx - 2018 LIS phytoplankton count.csv',
 'LIS_2019-Phytoplankton_Final Report Data.xlsx - 2019 LIS phytoplankton count.csv',
 'LIS_2020-Phytoplankton_Final Report Data.xlsx - 2020 LIS phytoplankton count.csv',
 'LIS_2021-Phytoplankton_Final Report Data.xlsx - 2021 LIS phytoplankton count.csv']
In [3]:
def percentages(df, column):
    df = df.groupby([column], as_index=False)['Totals'].sum()
    df['Percentages'] = round(((df['Totals'] / df['Totals'].sum()) * 100), 1)
    df = df.loc[(df[column] != "") & (df['Totals'] != 0)]
    return df
In [21]:
season2month = {
    'Winter': ['January', 'February', 'March'],
    'Spring': ['April', 'May', 'June'],
    'Summer': ['July', 'August', 'September'],
    'Fall': ['October', 'November', 'December']
}

1. What fraction of the total cell number are mixotrophs and what fraction are phytoplankton (strict phototrophs)?¶

For this question, we could also aggregate the data by adding all the surface samples together on a given sampling day and comparing that to the bottom samples. Or we could see if the fraction of mixoplankton changes as we go from West to East (stations A to K), because there is a big decrease in the amount of nutrients like nitrogen that are added to the Sound as you get farther East (away from NYC), so there might be more of a need for mixoplankton to get their nitrogen by eating as you go to the East.¶

In [70]:
def seasonal_trophic_strategy_per_station(csv_name, season):

    # Get months corresponding to season
    months = season2month.get(season)
    
    # Clean data
    classified = Classifier(csv_name)
    by_station_SB = classified.add_multiheader(classified.all_classified)
    removed_columns = by_station_SB.loc[:, by_station_SB.columns.get_level_values(2).isin(['Status', 'Phylum', 'Genus', 'Species'])].copy()
    removed_columns.columns = removed_columns.columns.get_level_values(2)
    other_columns = by_station_SB.loc[:, ~by_station_SB.columns.get_level_values(2).isin(['Status', 'Phylum', 'Genus', 'Species', 'Totals'])]
    other_columns = other_columns.loc[:, other_columns.columns.get_level_values(0).isin(months)]
    other_columns.columns = other_columns.columns.get_level_values(1)
    other_columns = other_columns.groupby(other_columns.columns.str[:3], axis=1).sum()
    by_station_SB = pd.concat([removed_columns, other_columns ], axis=1)
    by_station_SB.loc[by_station_SB['Genus']=='Protoperidinium', 'Status'] = 'Protozooplankton'
    by_station_SB = by_station_SB.replace(['No', 'Yes'], ['Phytoplankton', 'Mixoplankton']).drop(['Phylum', 'Genus', 'Species'], axis=1).replace(['No', 'Yes'], ['Phytoplankton', 'Mixoplankton']).groupby('Status').sum()
    by_station_SB.index.name = None
    by_station_SB = by_station_SB.transpose().reset_index().rename(columns={"index": "Station"})
    by_station_SB['Totals'] = by_station_SB[['Mixoplankton', "Phytoplankton", "Protozooplankton"]].sum(axis=1)
    by_station_SB[['Mixoplankton %', "Phytoplankton %", "Protozooplankton %"]] = by_station_SB[['Mixoplankton', "Phytoplankton", "Protozooplankton"]].div(by_station_SB[['Mixoplankton', "Phytoplankton", "Protozooplankton"]].sum(axis=1), axis=0) * 100
    
    # Get year
    year = re.search(r'\b(\d{4})\b', csv_name).group(1) if re.search(r'\b(\d{4})\b', csv_name) else 'Year not found'
    
    # Plot Stacked Bar Chart
    ax = by_station_SB.plot(kind='bar', x='Station', y=['Mixoplankton %', 'Phytoplankton %', 'Protozooplankton %'], stacked=True, figsize=(15, 7), xlabel="Stations", ylabel="Trophic Strategy Percentages", legend=True, title=f"Trophic Strategy per Station (S/B) in LIS in {season} {year}", edgecolor='black', width=.9)
    for container in ax.containers:
        ax.bar_label(container, labels=[f'{bar.get_height():.1f}%' if bar.get_height() > 0 else '' for bar in container], label_type='center', fmt='%.1f%%', color='black')
    ax.legend(bbox_to_anchor=(0.5, -0.1), loc='upper center', ncol=3)
    ax.set_yticklabels([f'{int(tick)}%' for tick in ax.get_yticks()])
    plt.xticks(rotation=0)
        
    plt.show()
    display(by_station_SB)
In [71]:
for csv_name in csvs:
    # Get map for each season
    for season in season2month.keys():
        seasonal_trophic_strategy_per_station(csv_name, season)
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4S 1636800 1723260 0 3360060 48.713416 51.286584 0.0
1 B3S 595452 1786312 0 2381764 25.000462 74.999538 0.0
2 C1S 638000 2121548 0 2759548 23.119728 76.880272 0.0
3 D3S 580800 2344980 0 2925780 19.851117 80.148883 0.0
4 E1S 110836 1637504 0 1748340 6.339499 93.660501 0.0
5 F2S 36652 1217964 0 1254616 2.921372 97.078628 0.0
6 H4S 155452 2462680 0 2618132 5.937516 94.062484 0.0
7 I2S 124036 1466608 0 1590644 7.797848 92.202152 0.0
8 J2S 140756 1856096 0 1996852 7.048895 92.951105 0.0
9 K2S 51260 603592 0 654852 7.827723 92.172277 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4S 1739136 3765156 0 5504292 31.595998 68.404002 0.0
1 B3S 1999008 3097380 0 5096388 39.224015 60.775985 0.0
2 C1S 1506252 2057484 0 3563736 42.266094 57.733906 0.0
3 D3S 2230756 2333100 0 4563856 48.878755 51.121245 0.0
4 E1S 1865600 1547084 0 3412684 54.666649 45.333351 0.0
5 F2S 853512 1704956 0 2558468 33.360277 66.639723 0.0
6 H4S 2069018 972185 0 3041203 68.032880 31.967120 0.0
7 I2S 1047156 451572 0 1498728 69.869649 30.130351 0.0
8 J2S 1033956 381084 0 1415040 73.069030 26.930970 0.0
9 K2S 852060 347292 0 1199352 71.043363 28.956637 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 720104 158180 0 878284 81.989880 18.010120 0.000000
1 A4S 1170356 3456772 0 4627128 25.293357 74.706643 0.000000
2 B3B 243408 232892 1452 477752 50.948609 48.747467 0.303923
3 B3S 818400 850564 2904 1671868 48.951233 50.875069 0.173698
4 C1B 186208 394328 0 580536 32.075186 67.924814 0.000000
5 C1S 508904 690668 22000 1221572 41.659763 56.539279 1.800958
6 D3B 146652 221364 0 368016 39.849354 60.150646 0.000000
7 D3S 626252 1300772 8800 1935824 32.350668 67.194745 0.454587
8 E1B 202400 235884 1452 439736 46.027617 53.642185 0.330198
9 E1S 349052 1218580 1452 1569084 22.245590 77.661872 0.092538
10 F2B 124652 388388 0 513040 24.296741 75.703259 0.000000
11 F2S 328460 1360832 0 1689292 19.443649 80.556351 0.000000
12 H4B 133452 266816 0 400268 33.340662 66.659338 0.000000
13 H4S 360756 1769988 0 2130744 16.930987 83.069013 0.000000
14 I2B 177452 342320 0 519772 34.140354 65.859646 0.000000
15 I2S 108504 2122076 0 2230580 4.864385 95.135615 0.000000
16 J2B 244904 677336 0 922240 26.555344 73.444656 0.000000
17 J2S 243452 798996 0 1042448 23.353875 76.646125 0.000000
18 K2B 200860 406032 0 606892 33.096498 66.903502 0.000000
19 K2S 99616 583440 0 683056 14.583870 85.416130 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 224400 236016 0 460416 48.738532 51.261468 0.0
1 A4S 356400 212476 0 568876 62.649857 37.350143 0.0
2 B3B 422400 228624 0 651024 64.882401 35.117599 0.0
3 B3S 357852 216920 0 574772 62.259818 37.740182 0.0
4 C1B 272800 448712 0 721512 37.809489 62.190511 0.0
5 C1S 230252 270996 0 501248 45.935744 54.064256 0.0
6 D3B 118800 332816 0 451616 26.305534 73.694466 0.0
7 D3S 63052 205040 0 268092 23.518792 76.481208 0.0
8 E1B 139304 277156 0 416460 33.449551 66.550449 0.0
9 E1S 80652 166980 0 247632 32.569296 67.430704 0.0
10 F2B 256652 214074 0 470726 54.522589 45.477411 0.0
11 F2S 265408 209484 0 474892 55.888076 44.111924 0.0
12 H4B 107052 190564 0 297616 35.969840 64.030160 0.0
13 H4S 494252 140624 0 634876 77.850163 22.149837 0.0
14 I2B 136400 192104 0 328504 41.521564 58.478436 0.0
15 I2S 237556 209528 0 447084 53.134534 46.865466 0.0
16 J2B 74800 143660 0 218460 34.239678 65.760322 0.0
17 J2S 20504 203544 0 224048 9.151610 90.848390 0.0
18 K2B 33704 230120 0 263824 12.775183 87.224817 0.0
19 K2S 7304 234476 0 241780 3.020928 96.979072 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 242000 784652 0 1026652 23.571765 76.428235 0.0
1 A4S 167200 912255 0 1079455 15.489298 84.510702 0.0
2 B3B 259600 507452 0 767052 33.843859 66.156141 0.0
3 B3S 44000 522104 0 566104 7.772423 92.227577 0.0
4 C1B 146652 745052 0 891704 16.446265 83.553735 0.0
5 C1S 61600 444400 0 506000 12.173913 87.826087 0.0
6 D3B 193600 740653 0 934253 20.722438 79.277562 0.0
7 D3S 184800 662860 0 847660 21.801194 78.198806 0.0
8 E1B 220000 467852 0 687852 31.983624 68.016376 0.0
9 E1S 123200 620356 0 743556 16.569028 83.430972 0.0
10 F2B 224400 461956 0 686356 32.694403 67.305597 0.0
11 F2S 162800 680460 0 843260 19.306027 80.693973 0.0
12 H4B 220000 1297956 0 1517956 14.493174 85.506826 0.0
13 H4S 134904 356356 0 491260 27.460815 72.539185 0.0
14 I2B 5808 680504 0 686312 0.846262 99.153738 0.0
15 I2S 211200 523468 0 734668 28.747679 71.252321 0.0
16 J2B 51304 1658714 0 1710018 3.000202 96.999798 0.0
17 J2S 192104 478016 0 670120 28.667104 71.332896 0.0
18 K2B 88000 596816 0 684816 12.850167 87.149833 0.0
19 K2S 29304 319572 0 348876 8.399546 91.600454 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 872652 8024060 0 8896712 9.808702 90.191298 0.000000
1 A4S 423852 8924564 0 9348416 4.533945 95.466055 0.000000
2 B3B 1377200 5177304 0 6554504 21.011506 78.988494 0.000000
3 B3S 479600 4790060 0 5269660 9.101156 90.898844 0.000000
4 C1B 674080 4436564 0 5110644 13.189727 86.810273 0.000000
5 C1S 466400 5780104 0 6246504 7.466577 92.533423 0.000000
6 D3B 397452 4136000 0 4533452 8.767094 91.232906 0.000000
7 D3S 435600 3801556 0 4237156 10.280481 89.719519 0.000000
8 E1B 462000 3407052 0 3869052 11.940910 88.059090 0.000000
9 E1S 343200 2719159 0 3062359 11.207047 88.792953 0.000000
10 F2B 888756 3935008 0 4823764 18.424533 81.575467 0.000000
11 F2S 1029600 2505008 0 3534608 29.129114 70.870886 0.000000
12 H4B 228800 2395009 0 2623809 8.720147 91.279853 0.000000
13 H4S 416504 857912 0 1274416 32.681950 67.318050 0.000000
14 I2B 265452 3415852 0 3681304 7.210814 92.789186 0.000000
15 I2S 303600 2257112 1452 2562164 11.849359 88.093971 0.056671
16 J2B 432652 1762904 0 2195556 19.705806 80.294194 0.000000
17 J2S 335852 1403600 0 1739452 19.307920 80.692080 0.000000
18 K2B 154000 1522312 0 1676312 9.186834 90.813166 0.000000
19 K2S 321200 1405052 0 1726252 18.606785 81.393215 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 88000 280104 0 368104 23.906287 76.093713 0.000000
1 A4S 426800 1501852 0 1928652 22.129446 77.870554 0.000000
2 B3B 259160 309760 0 568920 45.552978 54.447022 0.000000
3 B3S 896104 3429055 4400 4329559 20.697350 79.201023 0.101627
4 C1B 88880 309320 0 398200 22.320442 77.679558 0.000000
5 C1S 885852 1893452 0 2779304 31.873160 68.126840 0.000000
6 D3B 353320 335412 0 688732 51.300070 48.699930 0.000000
7 D3S 466400 966504 0 1432904 32.549285 67.450715 0.000000
8 E1B 112640 370422 0 483062 23.317918 76.682082 0.000000
9 E1S 388652 1525304 0 1913956 20.306214 79.693786 0.000000
10 F2B 118800 308340 0 427140 27.812895 72.187105 0.000000
11 F2S 484000 1168860 0 1652860 29.282577 70.717423 0.000000
12 H4B 265888 452707 0 718595 37.001092 62.998908 0.000000
13 H4S 112904 608564 0 721468 15.649204 84.350796 0.000000
14 I2B 213400 846067 0 1059467 20.142204 79.857796 0.000000
15 I2S 70400 797764 0 868164 8.109067 91.890933 0.000000
16 J2B 17600 582076 0 599676 2.934918 97.065082 0.000000
17 J2S 66000 662904 0 728904 9.054690 90.945310 0.000000
18 K2B 22000 412104 0 434104 5.067910 94.932090 0.000000
19 K2S 23408 297660 0 321068 7.290667 92.709333 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 44000 837364 0 881364 4.992262 95.007738 0.0
1 A4S 470800 967780 0 1438580 32.726717 67.273283 0.0
2 B3B 35200 620224 0 655424 5.370569 94.629431 0.0
3 B3S 463452 793144 0 1256596 36.881543 63.118457 0.0
4 C1B 184800 536712 0 721512 25.612880 74.387120 0.0
5 C1S 431200 813736 0 1244936 34.636319 65.363681 0.0
6 D1B 88000 225852 0 313852 28.038693 71.961307 0.0
7 D3B 30800 325556 0 356356 8.643042 91.356958 0.0
8 D3S 316800 1206920 0 1523720 20.791221 79.208779 0.0
9 E1B 23452 583616 0 607068 3.863159 96.136841 0.0
10 E1S 107052 888712 0 995764 10.750740 89.249260 0.0
11 F2B 98252 476520 0 574772 17.094083 82.905917 0.0
12 F2S 52800 585068 0 637868 8.277575 91.722425 0.0
13 H4B 8800 448668 0 457468 1.923632 98.076368 0.0
14 H4S 52800 378312 0 431112 12.247397 87.752603 0.0
15 I2B 35200 284460 0 319660 11.011700 88.988300 0.0
16 I2S 119680 403855 0 523535 22.859981 77.140019 0.0
17 J2B 0 316712 0 316712 0.000000 100.000000 0.0
18 J2S 37532 328660 0 366192 10.249268 89.750732 0.0
19 K2B 1452 80565 0 82017 1.770365 98.229635 0.0
20 K2S 10252 166980 0 177232 5.784508 94.215492 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 35200 987008 0 1022208 3.443526 96.556474 0.0
1 A4S 42504 579260 0 621764 6.836034 93.163966 0.0
2 B3B 120252 447216 0 567468 21.190975 78.809025 0.0
3 B3S 105600 362252 0 467852 22.571240 77.428760 0.0
4 C1B 118800 862356 0 981156 12.108166 87.891834 0.0
5 C1S 96800 351868 0 448668 21.574973 78.425027 0.0
6 D3B 36652 884312 0 920964 3.979743 96.020257 0.0
7 D3S 2904 376860 0 379764 0.764685 99.235315 0.0
8 E1B 1452 523512 0 524964 0.276590 99.723410 0.0
9 E1S 23452 281512 0 304964 7.690088 92.309912 0.0
10 F2B 63052 645260 0 708312 8.901727 91.098273 0.0
11 F2S 41052 529364 0 570416 7.196853 92.803147 0.0
12 H4B 73304 495616 0 568920 12.884764 87.115236 0.0
13 H4S 127600 222816 0 350416 36.413862 63.586138 0.0
14 I2B 93852 549912 0 643764 14.578634 85.421366 0.0
15 I2S 88000 878460 0 966460 9.105395 90.894605 0.0
16 J2B 0 740520 0 740520 0.000000 100.000000 0.0
17 J2S 52800 469172 0 521972 10.115485 89.884515 0.0
18 K2B 8800 343024 0 351824 2.501251 97.498749 0.0
19 K2S 17600 403260 0 420860 4.181913 95.818087 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 211200 394460 0 605660 34.871050 65.128950 0.0
1 A4S 457600 1013408 0 1471008 31.107921 68.892079 0.0
2 B3B 274252 649572 0 923824 29.686607 70.313393 0.0
3 B3S 331452 1793660 0 2125112 15.596919 84.403081 0.0
4 C1B 167200 756712 0 923912 18.096962 81.903038 0.0
5 C1S 139304 2141260 0 2280564 6.108314 93.891686 0.0
6 D3B 243452 1029468 0 1272920 19.125475 80.874525 0.0
7 D3S 639452 1186372 0 1825824 35.022653 64.977347 0.0
8 E1B 52800 1126312 0 1179112 4.477946 95.522054 0.0
9 E1S 41008 821304 0 862312 4.755587 95.244413 0.0
10 F2B 136400 1550164 0 1686564 8.087449 91.912551 0.0
11 F2S 95304 1799468 0 1894772 5.029840 94.970160 0.0
12 H4B 63052 1642608 0 1705660 3.696634 96.303366 0.0
13 H4S 61556 1299408 0 1360964 4.522970 95.477030 0.0
14 I2B 152504 951764 0 1104268 13.810416 86.189584 0.0
15 I2S 123200 548504 0 671704 18.341412 81.658588 0.0
16 J2B 134904 1124860 0 1259764 10.708672 89.291328 0.0
17 J2S 46904 529364 0 576268 8.139269 91.860731 0.0
18 K2B 45452 414964 0 460416 9.871942 90.128058 0.0
19 K2S 39600 698060 0 737660 5.368327 94.631673 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 484000 486860 0 970860 49.852708 50.147292 0.000000
1 A4S 167156 1969572 0 2136728 7.822989 92.177011 0.000000
2 B3B 165704 351868 0 517572 32.015642 67.984358 0.000000
3 B3S 217008 6567660 0 6784668 3.198506 96.801494 0.000000
4 C1B 243452 335632 0 579084 42.040878 57.959122 0.000000
5 C1S 470756 5521824 0 5992580 7.855648 92.144352 0.000000
6 D3B 133452 344520 0 477972 27.920464 72.079536 0.000000
7 D3S 214060 721512 0 935572 22.880120 77.119880 0.000000
8 E1B 76252 324790 0 401042 19.013470 80.986530 0.000000
9 E1S 41052 614416 0 655468 6.263006 93.736994 0.000000
10 F2B 90904 366564 0 457468 19.871117 80.128883 0.000000
11 F2S 101200 659780 0 760980 13.298641 86.701359 0.000000
12 H4B 22000 435424 0 457424 4.809542 95.190458 0.000000
13 H4S 167200 742016 0 909216 18.389470 81.610530 0.000000
14 I2B 32252 3062180 0 3094432 1.042259 98.957741 0.000000
15 I2S 640904 1878624 0 2519528 25.437463 74.562537 0.000000
16 J2B 0 284460 0 284460 0.000000 100.000000 0.000000
17 J2S 0 346104 0 346104 0.000000 100.000000 0.000000
18 K2B 26400 1226632 0 1253032 2.106890 97.893110 0.000000
19 K2S 60060 2066328 1452 2127840 2.822581 97.109181 0.068238
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 40304 2331032 0 2371336 1.699633 98.300367 0.0
1 A4S 32252 1403468 0 1435720 2.246399 97.753601 0.0
2 B3B 27852 1636624 0 1664476 1.673319 98.326681 0.0
3 B3S 45452 1438536 0 1483988 3.062828 96.937172 0.0
4 C1B 7304 1113112 0 1120416 0.651901 99.348099 0.0
5 C1S 16104 871024 0 887128 1.815296 98.184704 0.0
6 D3B 42504 231572 0 274076 15.508107 84.491893 0.0
7 D3S 71808 438416 0 510224 14.073819 85.926181 0.0
8 E1B 10252 162580 0 172832 5.931772 94.068228 0.0
9 E1S 29304 298936 0 328240 8.927614 91.072386 0.0
10 F2B 101200 183084 0 284284 35.598205 64.401795 0.0
11 F2S 35200 252120 0 287320 12.251149 87.748851 0.0
12 H4B 2904 284196 0 287100 1.011494 98.988506 0.0
13 H4S 27852 152196 0 180048 15.469208 84.530792 0.0
14 I2B 8800 255068 0 263868 3.335001 96.664999 0.0
15 I2S 114356 127380 0 241736 47.306152 52.693848 0.0
16 J2B 14652 244026 0 258678 5.664185 94.335815 0.0
17 J2S 17600 237292 0 254892 6.904885 93.095115 0.0
18 K2B 36652 155188 0 191840 19.105505 80.894495 0.0
19 K2S 2904 290180 0 293084 0.990842 99.009158 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 52756 3229424 0 3282180 1.607346 98.392654 0.0
1 A4S 114400 2094180 0 2208580 5.179799 94.820201 0.0
2 B3B 20504 2881912 0 2902416 0.706446 99.293554 0.0
3 B3S 58652 1728232 0 1786884 3.282362 96.717638 0.0
4 C1B 42504 2959572 0 3002076 1.415820 98.584180 0.0
5 C1S 27852 1743676 0 1771528 1.572202 98.427798 0.0
6 D3B 76252 2752816 0 2829068 2.695305 97.304695 0.0
7 D3S 46904 2296008 0 2342912 2.001953 97.998047 0.0
8 E1B 11704 2436016 0 2447720 0.478159 99.521841 0.0
9 E1S 32252 1572912 0 1605164 2.009265 97.990735 0.0
10 F2B 26400 2238060 0 2264460 1.165841 98.834159 0.0
11 F2S 13200 1608816 0 1622016 0.813802 99.186198 0.0
12 H4B 30800 2325972 0 2356772 1.306872 98.693128 0.0
13 H4S 2904 2019512 0 2022416 0.143591 99.856409 0.0
14 I2B 17600 1382920 0 1400520 1.256676 98.743324 0.0
15 I2S 11704 715572 0 727276 1.609293 98.390707 0.0
16 J2B 21956 1183380 0 1205336 1.821567 98.178433 0.0
17 J2S 16104 778624 0 794728 2.026354 97.973646 0.0
18 K2B 0 653796 0 653796 0.000000 100.000000 0.0
19 K2S 1452 564476 0 565928 0.256570 99.743430 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 353452 2638020 1452 2992924 11.809588 88.141897 0.048514
1 A4S 624800 3484712 0 4109512 15.203752 84.796248 0.000000
2 B3B 247852 2422860 0 2670712 9.280372 90.719628 0.000000
3 B3S 293304 2632432 0 2925736 10.024965 89.975035 0.000000
4 C1B 229548 2321660 0 2551208 8.997620 91.002380 0.000000
5 C1S 200904 1400608 0 1601512 12.544645 87.455355 0.000000
6 D3B 441452 2631024 0 3072476 14.367956 85.632044 0.000000
7 D3S 256652 2456564 0 2713216 9.459328 90.540672 0.000000
8 E1B 441452 1997468 0 2438920 18.100307 81.899693 0.000000
9 E1S 140800 2029764 0 2170564 6.486793 93.513207 0.000000
10 F2B 199452 2355452 0 2554904 7.806634 92.193366 0.000000
11 F2S 105600 2120756 0 2226356 4.743177 95.256823 0.000000
12 H4B 243452 980364 0 1223816 19.892860 80.107140 0.000000
13 H4S 120252 536712 0 656964 18.304199 81.695801 0.000000
14 I2B 33704 1286208 0 1319912 2.553504 97.446496 0.000000
15 I2S 111452 967868 0 1079320 10.326131 89.673869 0.000000
16 J2B 233200 1412356 0 1645556 14.171502 85.828498 0.000000
17 J2S 360800 1283216 0 1644016 21.946258 78.053742 0.000000
18 K2B 57156 871112 0 928268 6.157274 93.842726 0.000000
19 K2S 62260 510268 0 572528 10.874577 89.125423 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 668800 436876 0 1105676 60.487883 39.512117 0.0
1 A4S 1295052 1501764 0 2796816 46.304512 53.695488 0.0
2 B3B 409904 194172 0 604076 67.856362 32.143638 0.0
3 B3S 2803504 1063216 0 3866720 72.503414 27.496586 0.0
4 C1B 35200 38764 0 73964 47.590720 52.409280 0.0
5 C1S 1231208 851928 0 2083136 59.103582 40.896418 0.0
6 D3B 327052 103312 0 430364 75.994275 24.005725 0.0
7 D3S 630652 661364 0 1292016 48.811470 51.188530 0.0
8 E1B 221452 139172 0 360624 61.408004 38.591996 0.0
9 E1S 866800 512468 0 1379268 62.844929 37.155071 0.0
10 F2B 375452 360580 0 736032 51.010282 48.989718 0.0
11 F2S 141504 432520 0 574024 24.651234 75.348766 0.0
12 H4B 110704 355564 0 466268 23.742569 76.257431 0.0
13 H4S 541200 370216 0 911416 59.380129 40.619871 0.0
14 I2B 291852 163284 0 455136 64.124130 35.875870 0.0
15 I2S 545566 376860 0 922426 59.144690 40.855310 0.0
16 J2B 46508 181456 0 227964 20.401467 79.598533 0.0
17 J2S 240504 255024 0 495528 48.534896 51.465104 0.0
18 K2B 13860 195580 0 209440 6.617647 93.382353 0.0
19 K2S 272800 225632 0 498432 54.731638 45.268362 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 74800 193204 0 268004 27.910031 72.089969 0.0
1 A4S 343156 138336 0 481492 71.269305 28.730695 0.0
2 B3B 159852 180708 0 340560 46.937984 53.062016 0.0
3 B3S 275704 198396 0 474100 58.153132 41.846868 0.0
4 C1B 79200 190344 0 269544 29.382958 70.617042 0.0
5 C1S 249304 178640 0 427944 58.256220 41.743780 0.0
6 D3B 142252 162404 0 304656 46.692663 53.307337 0.0
7 D3S 79200 217536 0 296736 26.690391 73.309609 0.0
8 E1B 101904 144012 0 245916 41.438540 58.561460 0.0
9 E1S 116512 176352 0 292864 39.783654 60.216346 0.0
10 F2B 73304 380996 0 454300 16.135593 83.864407 0.0
11 F2S 27104 245344 0 272448 9.948320 90.051680 0.0
12 H4B 115852 307648 0 423500 27.355844 72.644156 0.0
13 H4S 96800 377432 0 474232 20.411950 79.588050 0.0
14 I2B 32208 349448 0 381656 8.439013 91.560987 0.0
15 I2S 71104 259116 0 330220 21.532312 78.467688 0.0
16 J2B 89452 202136 0 291588 30.677531 69.322469 0.0
17 J2S 109956 235796 0 345752 31.801985 68.198015 0.0
18 K2B 28512 157344 0 185856 15.340909 84.659091 0.0
19 K2S 24904 258456 0 283360 8.788820 91.211180 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 289564 2524016 0 2813580 10.291657 89.708343 0.0
1 A4S 198704 2495372 0 2694076 7.375590 92.624410 0.0
2 B3B 92400 2318668 0 2411068 3.832327 96.167673 0.0
3 B3S 232408 3415016 0 3647424 6.371839 93.628161 0.0
4 C1B 194260 1332320 0 1526580 12.725177 87.274823 0.0
5 C1S 349052 1502534 0 1851586 18.851514 81.148486 0.0
6 D3B 200816 1112364 0 1313180 15.292344 84.707656 0.0
7 D3S 206800 1069112 0 1275912 16.208014 83.791986 0.0
8 E1B 110704 1078616 0 1189320 9.308176 90.691824 0.0
9 E1S 211904 780032 0 991936 21.362669 78.637331 0.0
10 F2B 140756 1941060 0 2081816 6.761212 93.238788 0.0
11 F2S 64504 959068 0 1023572 6.301853 93.698147 0.0
12 H4B 248556 1507704 0 1756260 14.152574 85.847426 0.0
13 H4S 101904 420772 0 522676 19.496591 80.503409 0.0
14 I2B 44704 1208372 0 1253076 3.567541 96.432459 0.0
15 I2S 101904 650276 0 752180 13.547821 86.452179 0.0
16 J2B 5060 744876 0 749936 0.674724 99.325276 0.0
17 J2S 10252 524128 0 534380 1.918485 98.081515 0.0
18 K2B 68860 457380 0 526240 13.085284 86.914716 0.0
19 K2S 44000 623084 0 667084 6.595871 93.404129 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 836000 3475912 0 4311912 19.388151 80.611849 0.0
1 A4S 365200 7294364 0 7659564 4.767895 95.232105 0.0
2 B3B 611600 877712 0 1489312 41.065942 58.934058 0.0
3 B3S 507408 5595172 0 6102580 8.314647 91.685353 0.0
4 C1B 973852 818356 0 1792208 54.338113 45.661887 0.0
5 C1S 662904 1597904 0 2260808 29.321552 70.678448 0.0
6 D3B 198704 419364 0 618068 32.149213 67.850787 0.0
7 D3S 358556 1562572 0 1921128 18.663827 81.336173 0.0
8 E1B 83600 424908 0 508508 16.440253 83.559747 0.0
9 E1S 444400 408320 0 852720 52.115583 47.884417 0.0
10 F2B 326304 475860 0 802164 40.677966 59.322034 0.0
11 F2S 313104 592504 0 905608 34.573900 65.426100 0.0
12 H4B 286000 753808 0 1039808 27.505078 72.494922 0.0
13 H4S 277200 417208 0 694408 39.918895 60.081105 0.0
14 I2B 418704 656964 0 1075668 38.925021 61.074979 0.0
15 I2S 357104 600556 0 957660 37.289226 62.710774 0.0
16 J2B 46904 376068 0 422972 11.089150 88.910850 0.0
17 J2S 215600 397408 0 613008 35.170830 64.829170 0.0
18 K2B 97152 277112 0 374264 25.958147 74.041853 0.0
19 K2S 85052 290972 0 376024 22.618769 77.381231 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 528000 91080 0 619080 85.287846 14.712154 0.000000
1 A4S 621456 1330648 2904 1955008 31.787901 68.063558 0.148542
2 B3B 287452 71720 0 359172 80.031851 19.968149 0.000000
3 B3S 1727264 946484 0 2673748 64.600852 35.399148 0.000000
4 C1B 57200 88836 0 146036 39.168424 60.831576 0.000000
5 C1S 1203312 1708256 0 2911568 41.328659 58.671341 0.000000
6 D3B 155452 107008 0 262460 59.228835 40.771165 0.000000
7 D3S 541552 1192312 0 1733864 31.233822 68.766178 0.000000
8 E1B 111452 112904 0 224356 49.676407 50.323593 0.000000
9 E1S 894652 2330592 0 3225244 27.739049 72.260951 0.000000
10 F2B 64504 168828 0 233332 27.644729 72.355271 0.000000
11 F2S 330000 2428140 0 2758140 11.964585 88.035415 0.000000
12 H4B 52800 181016 0 233816 22.581859 77.418141 0.000000
13 H4S 59356 1731840 0 1791196 3.313764 96.686236 0.000000
14 I2B 14652 352924 0 367576 3.986114 96.013886 0.000000
15 I2S 139304 2088636 0 2227940 6.252592 93.747408 0.000000
16 J2B 113256 577236 0 690492 16.402218 83.597782 0.000000
17 J2S 90904 1161688 0 1252592 7.257271 92.742729 0.000000
18 K2B 30800 289784 0 320584 9.607466 90.392534 0.000000
19 K2S 115104 1214972 0 1330076 8.653942 91.346058 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 244904 237688 0 482592 50.747629 49.252371 0.0
1 A4S 214104 281908 0 496012 43.165085 56.834915 0.0
2 B3B 17556 241692 0 259248 6.771894 93.228106 0.0
3 B3S 82104 259688 0 341792 24.021627 75.978373 0.0
4 C1B 22000 225148 0 247148 8.901549 91.098451 0.0
5 C1S 228756 133980 0 362736 63.064047 36.935953 0.0
6 D3B 111452 119812 0 231264 48.192542 51.807458 0.0
7 D3S 34408 179520 0 213928 16.083916 83.916084 0.0
8 E1B 48396 150304 0 198700 24.356316 75.643684 0.0
9 E1S 221452 322476 0 543928 40.713477 59.286523 0.0
10 F2B 35200 152460 0 187660 18.757327 81.242673 0.0
11 F2S 54252 442288 0 496540 10.926008 89.073992 0.0
12 FBS 17776 38764 0 56540 31.439689 68.560311 0.0
13 H4B 2904 237116 0 240020 1.209899 98.790101 0.0
14 H4S 68904 184932 0 253836 27.145086 72.854914 0.0
15 I2B 8800 107096 0 115896 7.593014 92.406986 0.0
16 I2S 26356 39380 0 65736 40.093708 59.906292 0.0
17 J2B 704 124476 0 125180 0.562390 99.437610 0.0
18 J2S 3432 99704 0 103136 3.327645 96.672355 0.0
19 K2B 0 107140 0 107140 0.000000 100.000000 0.0
20 K2S 4356 58432 0 62788 6.937631 93.062369 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 89452 6291912 0 6381364 1.401769 98.598231 0.000000
1 A4S 108856 5932036 0 6040892 1.801986 98.198014 0.000000
2 B3B 99704 2441120 0 2540824 3.924081 96.075919 0.000000
3 B3S 117304 6053784 2904 6173992 1.899970 98.052994 0.047036
4 C1B 48400 3662076 0 3710476 1.304415 98.695585 0.000000
5 C1S 54604 2621476 352 2676432 2.040179 97.946669 0.013152
6 D3B 255200 4159672 0 4414872 5.780462 94.219538 0.000000
7 D3S 49852 3159640 0 3209492 1.553268 98.446732 0.000000
8 E1B 280104 3490828 0 3770932 7.427978 92.572022 0.000000
9 E1S 13904 1844392 0 1858296 0.748212 99.251788 0.000000
10 F2B 66000 3149168 0 3215168 2.052770 97.947230 0.000000
11 F2S 154000 3654816 0 3808816 4.043251 95.956749 0.000000
12 H4B 76956 3632816 0 3709772 2.074413 97.925587 0.000000
13 H4S 133452 2171576 0 2305028 5.789604 94.210396 0.000000
14 I2B 45408 2205940 0 2251348 2.016925 97.983075 0.000000
15 I2S 124608 1586728 0 1711336 7.281329 92.718671 0.000000
16 J2B 11880 1042052 0 1053932 1.127207 98.872793 0.000000
17 J2S 111452 903188 0 1014640 10.984389 89.015611 0.000000
18 K2B 0 570636 0 570636 0.000000 100.000000 0.000000
19 K2S 66000 655204 0 721204 9.151364 90.848636 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 660000 1643972 5852 2309824 28.573606 71.173042 0.253353
1 A4S 228800 3000580 5852 3235232 7.072136 92.746981 0.180883
2 B3B 290356 1594472 39600 1924428 15.087912 82.854334 2.057754
3 B3S 400400 1919852 26400 2346652 17.062607 81.812386 1.125007
4 C1B 177452 1374076 0 1551528 11.437241 88.562759 0.000000
5 C1S 270028 1549768 2904 1822700 14.814725 85.025951 0.159324
6 D3B 325600 1367740 0 1693340 19.228271 80.771729 0.000000
7 D3S 356400 1413236 0 1769636 20.139735 79.860265 0.000000
8 E1B 422400 869616 8800 1300816 32.471925 66.851576 0.676498
9 E1S 209704 1051820 4400 1265924 16.565291 83.087136 0.347572
10 F2B 340252 987976 0 1328228 25.616987 74.383013 0.000000
11 F2S 38456 1520156 0 1558612 2.467323 97.532677 0.000000
12 H4B 214104 537240 0 751344 28.496135 71.503865 0.000000
13 H4S 211200 587664 0 798864 26.437541 73.562459 0.000000
14 I2B 308000 602096 0 910096 33.842584 66.157416 0.000000
15 I2S 381304 472296 0 853600 44.670103 55.329897 0.000000
16 J2B 272800 363220 176 636196 42.879867 57.092468 0.027664
17 J2S 189156 350152 176 539484 35.062393 64.904983 0.032624
18 K2B 57904 122188 0 180092 32.152455 67.847545 0.000000
19 K2S 132000 307824 0 439824 30.012005 69.987995 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 177452 126852 0 304304 58.314054 41.685946 0.000000
1 A4S 835384 1113068 0 1948452 42.874241 57.125759 0.000000
2 B3B 143704 93324 0 237028 60.627436 39.372564 0.000000
3 B3S 696608 791252 0 1487860 46.819459 53.180541 0.000000
4 C1B 85052 138688 0 223740 38.013766 61.986234 0.000000
5 C1S 990792 740740 704 1732236 57.197287 42.762072 0.040641
6 D3B 286000 89892 0 375892 76.085684 23.914316 0.000000
7 D3S 366652 563420 0 930072 39.421894 60.578106 0.000000
8 E1B 180400 85404 0 265804 67.869558 32.130442 0.000000
9 E1S 297704 269852 0 567556 52.453679 47.546321 0.000000
10 F2B 39600 145860 0 185460 21.352313 78.647687 0.000000
11 F2S 466356 251680 0 718036 64.948833 35.051167 0.000000
12 H4B 237776 127776 0 365552 65.045739 34.954261 0.000000
13 H4S 255376 279690 0 535066 47.727944 52.272056 0.000000
14 I2B 68904 103664 0 172568 39.928608 60.071392 0.000000
15 I2S 313544 493812 0 807356 38.835904 61.164096 0.000000
16 J2B 134992 331188 0 466180 28.957055 71.042945 0.000000
17 J2S 154176 228580 0 382756 40.280492 59.719508 0.000000
18 K2B 32428 117524 0 149952 21.625587 78.374413 0.000000
19 K2S 118976 626560 0 745536 15.958451 84.041549 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 49896 261932 0 311828 16.001129 83.998871 0.0
1 A4S 165704 239096 0 404800 40.934783 59.065217 0.0
2 B3B 51304 214280 0 265584 19.317429 80.682571 0.0
3 B3S 234608 319484 0 554092 42.340983 57.659017 0.0
4 C1B 156904 180620 0 337524 46.486768 53.513232 0.0
5 C1S 434280 122936 0 557216 77.937461 22.062539 0.0
6 D3B 35508 185768 0 221276 16.046928 83.953072 0.0
7 D3S 242176 279224 0 521400 46.447257 53.552743 0.0
8 E1B 49104 134068 0 183172 26.807591 73.192409 0.0
9 E1S 146652 135740 0 282392 51.932066 48.067934 0.0
10 F2B 66088 185900 0 251988 26.226646 73.773354 0.0
11 F2S 139832 193424 0 333256 41.959335 58.040665 0.0
12 H4B 118976 176396 0 295372 40.280054 59.719946 0.0
13 H4S 186428 214544 0 400972 46.494020 53.505980 0.0
14 I2B 27808 341484 0 369292 7.530085 92.469915 0.0
15 I2S 68904 205700 0 274604 25.092133 74.907867 0.0
16 J2B 69608 284196 0 353804 19.674170 80.325830 0.0
17 J2S 20504 219252 0 239756 8.552028 91.447972 0.0
18 K2B 3080 100012 0 103092 2.987623 97.012377 0.0
19 K2S 1628 182556 0 184184 0.883899 99.116101 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 61600 632456 0 694056 8.875365 91.124635 0.0
1 A4S 154000 1205468 0 1359468 11.327961 88.672039 0.0
2 B3B 133452 494208 0 627660 21.261830 78.738170 0.0
3 B3S 550176 600512 0 1150688 47.812787 52.187213 0.0
4 C1B 321200 301400 0 622600 51.590106 48.409894 0.0
5 C1S 445852 425480 0 871332 51.169015 48.830985 0.0
6 D3B 215600 561000 0 776600 27.762040 72.237960 0.0
7 D3S 133452 282920 0 416372 32.051147 67.948853 0.0
8 E1B 88000 317416 0 405416 21.706099 78.293901 0.0
9 E1S 118008 192544 0 310552 37.999433 62.000567 0.0
10 F2B 39600 401148 0 440748 8.984726 91.015274 0.0
11 F2S 103004 356664 0 459668 22.408347 77.591653 0.0
12 H4B 180400 522764 0 703164 25.655466 74.344534 0.0
13 H4S 160160 243452 0 403612 39.681674 60.318326 0.0
14 I2B 28292 459844 0 488136 5.795926 94.204074 0.0
15 I2S 32428 266596 0 299024 10.844614 89.155386 0.0
16 J2B 17600 361724 0 379324 4.639833 95.360167 0.0
17 J2S 127688 444972 0 572660 22.297349 77.702651 0.0
18 K2B 39600 357852 0 397452 9.963467 90.036533 0.0
19 K2S 24156 325248 0 349404 6.913487 93.086513 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 0 0 0 0 NaN NaN NaN
1 A4S 0 0 0 0 NaN NaN NaN
2 B3B 0 0 0 0 NaN NaN NaN
3 B3S 0 0 0 0 NaN NaN NaN
4 C1B 0 0 0 0 NaN NaN NaN
5 C1S 0 0 0 0 NaN NaN NaN
6 D3B 0 0 0 0 NaN NaN NaN
7 D3S 0 0 0 0 NaN NaN NaN
8 E1B 0 0 0 0 NaN NaN NaN
9 E1S 0 0 0 0 NaN NaN NaN
10 F2B 0 0 0 0 NaN NaN NaN
11 F2S 0 0 0 0 NaN NaN NaN
12 H4B 0 0 0 0 NaN NaN NaN
13 H4S 0 0 0 0 NaN NaN NaN
14 I2B 0 0 0 0 NaN NaN NaN
15 I2S 0 0 0 0 NaN NaN NaN
16 J2B 0 0 0 0 NaN NaN NaN
17 J2S 0 0 0 0 NaN NaN NaN
18 K2B 0 0 0 0 NaN NaN NaN
19 K2S 0 0 0 0 NaN NaN NaN
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 44000 38720 0 82720 53.191489 46.808511 0.000000
1 A4S 1443200 1660956 0 3104156 46.492509 53.507491 0.000000
2 B3B 228800 261932 0 490732 46.624227 53.375773 0.000000
3 B3S 1249732 1984752 0 3234484 38.637755 61.362245 0.000000
4 C1B 338800 276628 0 615428 55.051119 44.948881 0.000000
5 C1S 830808 1600588 2904 2434300 34.129236 65.751469 0.119295
6 D3B 335852 126192 0 462044 72.688315 27.311685 0.000000
7 D3S 579304 744964 0 1324268 43.745224 56.254776 0.000000
8 E1B 112992 92576 0 205568 54.965753 45.034247 0.000000
9 E1S 1663376 1362416 2904 3028696 54.920533 44.983584 0.095883
10 F2B 382800 161084 0 543884 70.382655 29.617345 0.000000
11 F2S 1299452 567512 88 1867052 69.599133 30.396154 0.004713
12 H4B 225940 299508 0 525448 42.999498 57.000502 0.000000
13 H4S 1029688 1355376 0 2385064 43.172343 56.827657 0.000000
14 I2B 686620 259864 0 946484 72.544280 27.455720 0.000000
15 I2S 620576 928840 0 1549416 40.052252 59.947748 0.000000
16 J2B 107052 165660 0 272712 39.254598 60.745402 0.000000
17 J2S 110176 267300 0 377476 29.187551 70.812449 0.000000
18 K2B 101992 124124 0 226116 45.106052 54.893948 0.000000
19 K2S 64504 443740 0 508244 12.691542 87.308458 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 88000 66836 0 154836 56.834328 43.165672 0.000000
1 A4S 111628 63844 0 175472 63.615848 36.384152 0.000000
2 B3B 22000 93104 0 115104 19.113150 80.886850 0.000000
3 B3S 49852 93720 0 143572 34.722648 65.277352 0.000000
4 C1B 30800 64812 44 95656 32.198712 67.755290 0.045998
5 C1S 114400 56276 0 170676 67.027584 32.972416 0.000000
6 D3B 0 74096 0 74096 0.000000 100.000000 0.000000
7 D3S 4400 91872 0 96272 4.570384 95.429616 0.000000
8 E1B 23452 36916 0 60368 38.848397 61.151603 0.000000
9 E1S 66000 33528 0 99528 66.312997 33.687003 0.000000
10 F2B 30844 68464 0 99308 31.058928 68.941072 0.000000
11 F2S 27852 58080 0 85932 32.411674 67.588326 0.000000
12 H4B 30800 43516 0 74316 41.444642 58.555358 0.000000
13 H4S 22000 100716 0 122716 17.927573 82.072427 0.000000
14 I2B 22352 50820 0 73172 30.547204 69.452796 0.000000
15 I2S 35552 80960 0 116512 30.513595 69.486405 0.000000
16 J2B 0 60896 0 60896 0.000000 100.000000 0.000000
17 J2S 66396 65164 0 131560 50.468227 49.531773 0.000000
18 K2B 132 24772 0 24904 0.530035 99.469965 0.000000
19 K2S 1452 102168 0 103620 1.401274 98.598726 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 167200 781308 0 948508 17.627685 82.372315 0.0
1 A4S 57200 784564 0 841764 6.795254 93.204746 0.0
2 B3B 118800 589556 0 708356 16.771228 83.228772 0.0
3 B3S 8800 572044 0 580844 1.515037 98.484963 0.0
4 C1B 123200 520608 0 643808 19.136140 80.863860 0.0
5 C1S 118800 416592 0 535392 22.189349 77.810651 0.0
6 D3B 105600 299156 0 404756 26.089792 73.910208 0.0
7 D3S 107052 228756 0 335808 31.878931 68.121069 0.0
8 E1B 105600 243408 0 349008 30.257186 69.742814 0.0
9 E1S 14652 321596 0 336248 4.357498 95.642502 0.0
10 F2B 20504 192148 0 212652 9.642044 90.357956 0.0
11 F2S 158400 215556 0 373956 42.357924 57.642076 0.0
12 H4B 286000 466752 0 752752 37.993921 62.006079 0.0
13 H4S 105600 138160 0 243760 43.321300 56.678700 0.0
14 I2B 137852 759660 0 897512 15.359349 84.640651 0.0
15 I2S 63052 224664 0 287716 21.914666 78.085334 0.0
16 J2B 9504 669152 0 678656 1.400415 98.599585 0.0
17 J2S 9504 544852 0 554356 1.714422 98.285578 0.0
18 K2B 107052 298408 0 405460 26.402604 73.597396 0.0
19 K2S 61644 222860 0 284504 21.667182 78.332818 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 180400 727408 0 907808 19.872043 80.127957 0.0
1 A4S 655776 2240172 0 2895948 22.644605 77.355395 0.0
2 B3B 563200 352968 0 916168 61.473442 38.526558 0.0
3 B3S 1020976 2197844 0 3218820 31.718953 68.281047 0.0
4 C1B 202400 434060 0 636460 31.800899 68.199101 0.0
5 C1S 526856 2225608 0 2752464 19.141249 80.858751 0.0
6 D3B 107052 456368 0 563420 19.000390 80.999610 0.0
7 D3S 369600 440220 0 809820 45.639772 54.360228 0.0
8 E1B 303600 507452 0 811052 37.432865 62.567135 0.0
9 E1S 193952 298804 0 492756 39.360657 60.639343 0.0
10 F2B 365200 445808 0 811008 45.030382 54.969618 0.0
11 F2S 171600 689260 0 860860 19.933555 80.066445 0.0
12 H4B 393756 356840 0 750596 52.459112 47.540888 0.0
13 H4S 324808 752048 0 1076856 30.162622 69.837378 0.0
14 I2B 418000 543356 0 961356 43.480251 56.519749 0.0
15 I2S 102608 375320 0 477928 21.469343 78.530657 0.0
16 J2B 192104 353012 0 545116 35.240940 64.759060 0.0
17 J2S 182908 301356 0 484264 37.770307 62.229693 0.0
18 K2B 70400 351956 0 422356 16.668403 83.331597 0.0
19 K2S 70752 294756 0 365508 19.357169 80.642831 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 479556 104676 0 584232 82.083145 17.916855 0.0
1 A4S 1103960 1473868 0 2577828 42.825200 57.174800 0.0
2 B3B 471152 119680 0 590832 79.743819 20.256181 0.0
3 B3S 1236708 2074600 0 3311308 37.348021 62.651979 0.0
4 C1B 177452 76516 0 253968 69.871795 30.128205 0.0
5 C1S 975656 648120 0 1623776 60.085628 39.914372 0.0
6 D3B 501600 56144 0 557744 89.933733 10.066267 0.0
7 D3S 317856 389444 0 707300 44.939347 55.060653 0.0
8 E1B 532708 92312 0 625020 85.230553 14.769447 0.0
9 E1S 79200 98032 0 177232 44.687190 55.312810 0.0
10 F2B 202356 79068 0 281424 71.904315 28.095685 0.0
11 F2S 589996 308528 0 898524 65.662798 34.337202 0.0
12 H4B 24904 75856 0 100760 24.716157 75.283843 0.0
13 H4S 215600 108724 0 324324 66.476733 33.523267 0.0
14 I2B 82104 75064 0 157168 52.239642 47.760358 0.0
15 I2S 281600 260392 0 541992 51.956486 48.043514 0.0
16 J2B 22000 185548 0 207548 10.599958 89.400042 0.0
17 J2S 758296 401676 0 1159972 65.371923 34.628077 0.0
18 K2B 352 96448 0 96800 0.363636 99.636364 0.0
19 K2S 36740 273504 0 310244 11.842292 88.157708 0.0
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 40304 182336 0 222640 18.102767 81.897233 0.0
1 A4S 89452 205700 0 295152 30.307096 69.692904 0.0
2 B3B 140800 111892 0 252692 55.720007 44.279993 0.0
3 B3S 58696 110000 0 168696 34.793949 65.206051 0.0
4 C1B 9152 156596 0 165748 5.521635 94.478365 0.0
5 C1S 129360 459096 0 588456 21.982952 78.017048 0.0
6 D3B 13112 85272 0 98384 13.327370 86.672630 0.0
7 D3S 11748 50952 0 62700 18.736842 81.263158 0.0
8 E1B 13200 129228 0 142428 9.267841 90.732159 0.0
9 E1S 17556 109516 0 127072 13.815789 86.184211 0.0
10 F2B 8712 124960 0 133672 6.517446 93.482554 0.0
11 F2S 29304 119108 0 148412 19.745034 80.254966 0.0
12 H4B 79200 102916 0 182116 43.488765 56.511235 0.0
13 H4S 55748 198792 0 254540 21.901469 78.098531 0.0
14 I2B 13552 121704 0 135256 10.019519 89.980481 0.0
15 I2S 97152 62964 0 160116 60.676010 39.323990 0.0
16 J2B 3256 139392 0 142648 2.282542 97.717458 0.0
17 J2S 14652 108064 0 122716 11.939763 88.060237 0.0
18 K2B 5852 136708 0 142560 4.104938 95.895062 0.0
19 K2S 88 71456 0 71544 0.123001 99.876999 0.0
In [68]:
def yearly_trophic_strategy_per_station(csv_name):
    # Get year
    year = re.search(r'\b(\d{4})\b', csv_name).group(1) if re.search(r'\b(\d{4})\b', csv_name) else 'Year not found'

    # Clean data
    classified = Classifier(csv_name)
    by_station_SB = classified.add_multiheader(classified.all_classified)
    removed_columns = by_station_SB.loc[:, by_station_SB.columns.get_level_values(2).isin(['Status', 'Phylum', 'Genus', 'Species'])].copy()
    removed_columns.columns = removed_columns.columns.get_level_values(2)
    other_columns = by_station_SB.loc[:, ~by_station_SB.columns.get_level_values(2).isin(['Status', 'Phylum', 'Genus', 'Species', 'Totals'])]
    other_columns.columns = other_columns.columns.get_level_values(1)
    other_columns = other_columns.groupby(other_columns.columns.str[:3], axis=1).sum()
    by_station_SB = pd.concat([removed_columns, other_columns ], axis=1)
    by_station_SB.loc[by_station_SB['Genus']=='Protoperidinium', 'Status'] = 'Protozooplankton'
    by_station_SB = by_station_SB.replace(['No', 'Yes'], ['Phytoplankton', 'Mixoplankton']).drop(['Phylum', 'Genus', 'Species'], axis=1).replace(['No', 'Yes'], ['Phytoplankton', 'Mixoplankton']).groupby('Status').sum()
    by_station_SB.index.name = None
    by_station_SB = by_station_SB.transpose().reset_index().rename(columns={"index": "Station"})
    by_station_SB['Totals'] = by_station_SB[['Mixoplankton', "Phytoplankton", "Protozooplankton"]].sum(axis=1)
    by_station_SB[['Mixoplankton %', "Phytoplankton %", "Protozooplankton %"]] = by_station_SB[['Mixoplankton', "Phytoplankton", "Protozooplankton"]].div(by_station_SB[['Mixoplankton', "Phytoplankton", "Protozooplankton"]].sum(axis=1), axis=0) * 100
        
    # plot bars in stack manner
    ax = by_station_SB.plot(kind='bar', x='Station', y=['Mixoplankton %', 'Phytoplankton %', 'Protozooplankton %'], stacked=True, figsize=(15, 7), xlabel="Stations", ylabel="Trophic Strategy Percentages", legend=True, title=f"Trophic Strategy per Station (S/B) in LIS in {year}", edgecolor='black', width=.9)
    for container in ax.containers:
        ax.bar_label(container, labels=[f'{bar.get_height():.1f}%' if bar.get_height() > 0 else '' for bar in container], label_type='center', fmt='%.1f%%', color='black')
    ax.legend(bbox_to_anchor=(0.5, -0.1), loc='upper center', ncol=3)
    ax.set_yticklabels([f'{int(tick)}%' for tick in ax.get_yticks()])
    plt.xticks(rotation=0)
    
    plt.show()
    display(by_station_SB)
In [69]:
# Percentage of PLankton Trophic Strategy per Station
for csv_name in csvs:
    # Get pie chart for each year
    yearly_trophic_strategy_per_station(csv_name)
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 944504 394196 0 1338700 70.553821 29.446179 0.000000
1 A4S 4902692 9157664 0 14060356 34.868904 65.131096 0.000000
2 B3B 665808 461516 1452 1128776 58.984954 40.886411 0.128635
3 B3S 3770712 5951176 2904 9724792 38.774217 61.195921 0.029862
4 C1B 459008 843040 0 1302048 35.252771 64.747229 0.000000
5 C1S 2883408 5140696 22000 8046104 35.836077 63.890499 0.273424
6 D3B 265452 554180 0 819632 32.386730 67.613270 0.000000
7 D3S 3500860 6183892 8800 9693552 36.115348 63.793870 0.090782
8 E1B 341704 513040 1452 856196 39.909553 59.920859 0.169587
9 E1S 2406140 4570148 1452 6977740 34.483085 65.496106 0.020809
10 F2B 381304 602462 0 983766 38.759624 61.240376 0.000000
11 F2S 1484032 4493236 0 5977268 24.827931 75.172069 0.000000
12 H4B 240504 457380 0 697884 34.461888 65.538112 0.000000
13 H4S 3079478 5345477 0 8424955 36.551863 63.448137 0.000000
14 I2B 313852 534424 0 848276 36.998807 63.001193 0.000000
15 I2S 1517252 4249784 0 5767036 26.309043 73.690957 0.000000
16 J2B 319704 820996 0 1140700 28.027001 71.972999 0.000000
17 J2S 1438668 3239720 0 4678388 30.751361 69.248639 0.000000
18 K2B 234564 636152 0 870716 26.939209 73.060791 0.000000
19 K2S 1010240 1768800 0 2779040 36.352122 63.647878 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 1246652 9926180 0 11172832 11.157887 88.842113 0.000000
1 A4S 1488652 12306451 0 13795103 10.791163 89.208837 0.000000
2 B3B 1931160 6614740 0 8545900 22.597503 77.402497 0.000000
3 B3S 1883156 9534363 4400 11421919 16.487212 83.474266 0.038522
4 C1B 1094412 6027648 0 7122060 15.366509 84.633491 0.000000
5 C1S 1845052 8931692 0 10776744 17.120681 82.879319 0.000000
6 D1B 88000 225852 0 313852 28.038693 71.961307 0.000000
7 D3B 975172 5537621 0 6512793 14.973177 85.026823 0.000000
8 D3S 1403600 6637840 0 8041440 17.454585 82.545415 0.000000
9 E1B 818092 4828942 0 5647034 14.487110 85.512890 0.000000
10 E1S 962104 5753531 0 6715635 14.326330 85.673670 0.000000
11 F2B 1330208 5181824 0 6512032 20.426927 79.573073 0.000000
12 F2S 1729200 4939396 0 6668596 25.930496 74.069504 0.000000
13 H4B 723488 4594340 0 5317828 13.604953 86.395047 0.000000
14 H4S 717112 2201144 0 2918256 24.573307 75.426693 0.000000
15 I2B 519860 5226883 0 5746743 9.046168 90.953832 0.000000
16 I2S 704880 3982199 1452 4688531 15.034133 84.934898 0.030969
17 J2B 501556 4320406 0 4821962 10.401492 89.598508 0.000000
18 J2S 631488 2873180 0 3504668 18.018483 81.981517 0.000000
19 K2B 265452 2611797 0 2877249 9.225896 90.774104 0.000000
20 K2S 384164 2189264 0 2573428 14.928104 85.071896 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 770704 4199360 0 4970064 15.506923 84.493077 0.000000
1 A4S 699512 4965708 0 5665220 12.347482 87.652518 0.000000
2 B3B 588060 3085280 0 3673340 16.008864 83.991136 0.000000
3 B3S 699512 10162108 0 10861620 6.440218 93.559782 0.000000
4 C1B 536756 3067812 0 3604568 14.890994 85.109006 0.000000
5 C1S 722964 8885976 0 9608940 7.523868 92.476132 0.000000
6 D3B 456060 2489872 0 2945932 15.481009 84.518991 0.000000
7 D3S 928224 2723160 0 3651384 25.421155 74.578845 0.000000
8 E1B 140756 2137194 0 2277950 6.179065 93.820935 0.000000
9 E1S 134816 2016168 0 2150984 6.267643 93.732357 0.000000
10 F2B 391556 2745072 0 3136628 12.483342 87.516658 0.000000
11 F2S 272756 3240732 0 3513488 7.763112 92.236888 0.000000
12 H4B 161260 2857844 0 3019104 5.341320 94.658680 0.000000
13 H4S 384208 2416436 0 2800644 13.718559 86.281441 0.000000
14 I2B 287408 4818924 0 5106332 5.628463 94.371537 0.000000
15 I2S 966460 3432968 0 4399428 21.967856 78.032144 0.000000
16 J2B 149556 2393866 0 2543422 5.880110 94.119890 0.000000
17 J2S 117304 1581932 0 1699236 6.903338 93.096662 0.000000
18 K2B 117304 2139808 0 2257112 5.197084 94.802916 0.000000
19 K2S 120164 3457828 1452 3579444 3.357058 96.602377 0.040565
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 1149808 6497524 1452 7648784 15.032559 84.948457 0.018983
1 A4S 2377408 7218992 0 9596400 24.773957 75.226043 0.000000
2 B3B 838112 5679652 0 6517764 12.858888 87.141112 0.000000
3 B3S 3431164 5622276 0 9053440 37.899009 62.100991 0.000000
4 C1B 386452 5510340 0 5896792 6.553597 93.446403 0.000000
5 C1S 1709268 4174852 0 5884120 29.048830 70.951170 0.000000
6 D3B 987008 5649556 0 6636564 14.872274 85.127726 0.000000
7 D3S 1013408 5631472 0 6644880 15.250960 84.749040 0.000000
8 E1B 776512 4716668 0 5493180 14.135929 85.864071 0.000000
9 E1S 1156364 4291496 0 5447860 21.226023 78.773977 0.000000
10 F2B 674608 5335088 0 6009696 11.225327 88.774673 0.000000
11 F2S 287408 4407436 0 4694844 6.121780 93.878220 0.000000
12 H4B 500808 3969548 0 4470356 11.202866 88.797134 0.000000
13 H4S 761156 3303872 0 4065028 18.724496 81.275504 0.000000
14 I2B 375364 3181860 0 3557224 10.552161 89.447839 0.000000
15 I2S 739826 2319416 0 3059242 24.183311 75.816689 0.000000
16 J2B 391116 2979328 0 3370444 11.604287 88.395713 0.000000
17 J2S 727364 2552660 0 3280024 22.175569 77.824431 0.000000
18 K2B 99528 1877832 0 1977360 5.033378 94.966622 0.000000
19 K2S 361416 1558832 0 1920248 18.821319 81.178681 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 1898468 6328696 0 8227164 23.075607 76.924393 0.000000
1 A4S 1399464 11402292 2904 12804660 10.929334 89.047987 0.022679
2 B3B 1009008 3509792 0 4518800 22.329114 77.670886 0.000000
3 B3S 2549184 10216360 0 12765544 19.969255 80.030745 0.000000
4 C1B 1247312 2464660 0 3711972 33.602409 66.397591 0.000000
5 C1S 2444024 4942674 0 7386698 33.086827 66.913173 0.000000
6 D3B 666424 1758548 0 2424972 27.481719 72.518281 0.000000
7 D3S 1141316 4003516 0 5144832 22.183737 77.816263 0.000000
8 E1B 354152 1766732 0 2120884 16.698320 83.301680 0.000000
9 E1S 1772408 3841420 0 5613828 31.572182 68.427818 0.000000
10 F2B 566764 2738208 0 3304972 17.148829 82.851171 0.000000
11 F2S 761860 4422000 0 5183860 14.696770 85.303230 0.000000
12 FBS 17776 38764 0 56540 31.439689 68.560311 0.000000
13 H4B 590260 2679644 0 3269904 18.051294 81.948706 0.000000
14 H4S 507364 2754752 0 3262116 15.553218 84.446782 0.000000
15 I2B 486860 2325356 0 2812216 17.312326 82.687674 0.000000
16 I2S 624668 3378848 0 4003516 15.602985 84.397015 0.000000
17 J2B 165924 1822656 0 1988580 8.343843 91.656157 0.000000
18 J2S 320188 2182928 0 2503116 12.791577 87.208423 0.000000
19 K2B 196812 1131416 0 1328228 14.817637 85.182363 0.000000
20 K2S 248512 2187460 0 2435972 10.201759 89.798241 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 976800 8324668 5852 9307320 10.494965 89.442160 0.062875
1 A4S 1338744 10284780 5852 11629376 11.511744 88.437935 0.050321
2 B3B 585068 4343196 39600 4967864 11.777053 87.425823 0.797123
3 B3S 1448920 9084372 29304 10562596 13.717461 86.005107 0.277432
4 C1B 467808 5355460 0 5823268 8.033427 91.966573 0.000000
5 C1S 1749704 5034920 3960 6788584 25.774212 74.167455 0.058333
6 D3B 902308 5803072 0 6705380 13.456478 86.543522 0.000000
7 D3S 1015080 5415520 0 6430600 15.785152 84.214848 0.000000
8 E1B 932008 4579916 8800 5520724 16.881989 82.958612 0.159399
9 E1S 667964 3301804 4400 3974168 16.807644 83.081641 0.110715
10 F2B 511940 4468904 0 4980844 10.278178 89.721822 0.000000
11 F2S 798644 5620076 0 6418720 12.442418 87.557582 0.000000
12 H4B 647812 4474228 0 5122040 12.647539 87.352461 0.000000
13 H4S 786456 3253474 0 4039930 19.467070 80.532930 0.000000
14 I2B 450120 3253184 0 3703304 12.154552 87.845448 0.000000
15 I2S 888360 2758536 0 3646896 24.359346 75.640654 0.000000
16 J2B 489280 2020656 176 2510112 19.492357 80.500631 0.007012
17 J2S 475288 1701172 176 2176636 21.835897 78.156017 0.008086
18 K2B 93412 910360 0 1003772 9.306097 90.693903 0.000000
19 K2S 318604 1772144 0 2090748 15.238757 84.761243 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 193600 738012 0 931612 20.781184 79.218816 0.000000
1 A4S 1708828 2930268 0 4639096 36.835366 63.164634 0.000000
2 B3B 384252 849244 0 1233496 31.151459 68.848541 0.000000
3 B3S 1849760 2678984 0 4528744 40.844879 59.155121 0.000000
4 C1B 690800 642840 44 1333684 51.796378 48.200323 0.003299
5 C1S 1391060 2082344 2904 3476308 40.015442 59.901021 0.083537
6 D3B 551452 761288 0 1312740 42.007709 57.992291 0.000000
7 D3S 717156 1119756 0 1836912 39.041391 60.958609 0.000000
8 E1B 224444 446908 0 671352 33.431642 66.568358 0.000000
9 E1S 1847384 1588488 2904 3438776 53.722138 46.193413 0.084449
10 F2B 453244 630696 0 1083940 41.814492 58.185508 0.000000
11 F2S 1430308 982256 88 2412652 59.283643 40.712709 0.003647
12 H4B 437140 865788 0 1302928 33.550588 66.449412 0.000000
13 H4S 1211848 1699544 0 2911392 41.624350 58.375650 0.000000
14 I2B 737264 770528 0 1507792 48.896930 51.103070 0.000000
15 I2S 688556 1276396 0 1964952 35.041874 64.958126 0.000000
16 J2B 124652 588280 0 712932 17.484416 82.515584 0.000000
17 J2S 304260 777436 0 1081696 28.128051 71.871949 0.000000
18 K2B 141724 506748 0 648472 21.855069 78.144931 0.000000
19 K2S 90112 871156 0 961268 9.374285 90.625715 0.000000
No description has been provided for this image
Station Mixoplankton Phytoplankton Protozooplankton Totals Mixoplankton % Phytoplankton % Protozooplankton %
0 A4B 867460 1795728 0 2663188 32.572240 67.427760 0.0
1 A4S 1906388 4704304 0 6610692 28.837949 71.162051 0.0
2 B3B 1293952 1174096 0 2468048 52.428154 47.571846 0.0
3 B3S 2325180 4954488 0 7279668 31.940742 68.059258 0.0
4 C1B 512204 1187780 0 1699984 30.129931 69.870069 0.0
5 C1S 1750672 3749416 0 5500088 31.829891 68.170109 0.0
6 D3B 727364 896940 0 1624304 44.780041 55.219959 0.0
7 D3S 806256 1109372 0 1915628 42.088339 57.911661 0.0
8 E1B 955108 972400 0 1927508 49.551442 50.448558 0.0
9 E1S 305360 827948 0 1133308 26.944132 73.055868 0.0
10 F2B 596772 841984 0 1438756 41.478333 58.521667 0.0
11 F2S 949300 1332452 0 2281752 41.603996 58.396004 0.0
12 H4B 783860 1002364 0 1786224 43.883634 56.116366 0.0
13 H4S 701756 1197724 0 1899480 36.944637 63.055363 0.0
14 I2B 651508 1499784 0 2151292 30.284499 69.715501 0.0
15 I2S 544412 923340 0 1467752 37.091552 62.908448 0.0
16 J2B 226864 1347104 0 1573968 14.413508 85.586492 0.0
17 J2S 965360 1355948 0 2321308 41.586898 58.413102 0.0
18 K2B 183656 883520 0 1067176 17.209532 82.790468 0.0
19 K2S 169224 862576 0 1031800 16.400853 83.599147 0.0
In [9]:
# Total cells/L per Plankton Trophic Strategy
def trophic_strategy_for_total_pie(csv_name):
    # Get year
    year = re.search(r'\b(\d{4})\b', csv_name).group(1) if re.search(r'\b(\d{4})\b', csv_name) else 'Year not found'
    
    # Clean Data
    classified = Classifier(csv_name)
    df = classified.all_classified
    df.loc[df['Genus']=='Protoperidinium', 'Status'] = 'Protozooplankton'
    df = df.replace(['No', 'Yes'], ['Phytoplankton', 'Mixoplankton'])
    df = df.replace('Yes', 'Mixoplankton')
    counts = percentages(df, 'Status')

    # Pie Chart
    plt.title(f"Total cells/L per Plankton Type in LIS in {year}")
    plt.pie(counts['Percentages'], labels=counts['Status'], autopct='%1.3f%%')
    plt.legend(bbox_to_anchor=(.2, 1))
    
    plt.show()
    display(counts)
In [10]:
# Percentage of PLankton Trophic Strategy per Station
for csv_name in csvs:
    # Get pie chart for each year
    trophic_strategy_for_total_pie(csv_name)
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 30159886 35.022426
1 Phytoplankton 55917979 64.933378
2 Protozooplankton 38060 0.044196
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 21243460 15.655346
1 Phytoplankton 114445293 84.340341
2 Protozooplankton 5852 0.004313
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 8645340 10.612357
1 Phytoplankton 72818048 89.38586
2 Protozooplankton 1452 0.001782
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 18744098 17.813477
1 Phytoplankton 86478700 82.185143
2 Protozooplankton 1452 0.00138
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 18968748 19.994807
1 Phytoplankton 75896722 80.002132
2 Protozooplankton 2904 0.003061
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 15544320 14.472908
1 Phytoplankton 91760442 85.435735
2 Protozooplankton 98120 0.091357
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 15177844 39.951426
1 Phytoplankton 22806960 60.032939
2 Protozooplankton 5940 0.015635
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 17222656 34.554557
1 Phytoplankton 32619268 65.445443

2. What different types of mixoplankton are present and what is their relative abundance?¶

In [11]:
def mixoplankton_type_pie(csv_name):
    # Get year
    year = re.search(r'\b(\d{4})\b', csv_name).group(1) if re.search(r'\b(\d{4})\b', csv_name) else 'Year not found'

    # Clean Data
    classified = Classifier(csv_name)
    df = classified.mixoplankton_with_header
    df = df.loc[:, ~df.columns.get_level_values(2).isin(['Status', 'Phylum', 'Genus', 'Species', 'Evidence of mixoplankton activity', 'size class', 'Totals'])]
    df.columns = df.columns.get_level_values(1)
    df = pd.concat([df[[np.nan]], df.groupby(df.columns.str[0], axis=1).sum()], axis=1).rename(columns= {np.nan:'MFT'}).groupby('MFT').sum().reset_index()
    df['Totals'] = df.iloc[:, 1:].sum(axis=1)
    df = df[df['Totals'] != 0]
    df['Percentages'] = ((df['Totals'] / df['Totals'].sum()) * 100)

    # Pie Chart
    plt.title(f"Mixoplankton Functional Type in LIS in {year}")
    plt.pie(df['Percentages'], labels=df['MFT'], autopct='%1.3f%%')
    plt.legend(bbox_to_anchor=(.2, 1))
    
    plt.show()
    display(df)
In [12]:
for csv_name in csvs:
    # Get pie chart for each year
    mixoplankton_type_pie(csv_name)
No description has been provided for this image
MFT A B C D E F H I J K Totals Percentages
0 CM 5844292 4432120 3338016 3766312 2747844 1862432 3319982 1829652 1758372 1244804 30143826 99.94675
2 pSNCM 2904 4400 4400 0 0 2904 0 1452 0 0 16060 0.05325
No description has been provided for this image
MFT A B C D E F H I J K Totals Percentages
0 CM 2735304 3808464 2933612 2466772 1778744 3059408 1440600 1224740 1133044 649616 21230304 99.93807
2 pSNCM 0 5852 5852 0 1452 0 0 0 0 0 13156 0.06193
No description has been provided for this image
MFT A B C D E F H I J K Totals Percentages
0 CM 1458512 1270060 1249512 1378476 263868 649660 542564 1243616 265408 237468 8559144 99.002977
2 pSNCM 11704 17512 10208 5808 11704 14652 2904 10252 1452 0 86196 0.997023
No description has been provided for this image
MFT A B C D E F H I J K Totals Percentages
0 CM 3525764 4267120 2090660 1998964 1930720 962016 1261964 1113034 1117424 460944 18728610 99.917371
2 pSNCM 1452 2156 5060 1452 1452 0 0 2156 1056 0 14784 0.078873
3 pSNCM* 0 0 0 0 704 0 0 0 0 0 704 0.003756
No description has been provided for this image
MFT A B C D E F H I J K Totals Percentages
0 CM 3296524 3553176 3687024 1734876 2125108 1332496 1096920 1110824 485760 444972 18867680 99.467187
2 pSNCM 1408 5016 4312 2464 1452 13904 704 704 352 352 30668 0.161676
3 pSNCM* 0 0 0 70400 0 0 0 0 0 0 70400 0.371137
No description has been provided for this image
MFT A B C D E F H I J K Totals Percentages
0 CM 2311760 2020788 2215576 1917212 1598520 1304380 1403116 1335884 958540 411840 15477616 99.570879
1 eSNCM 0 0 0 0 0 0 30800 792 6028 176 37796 0.243150
2 pSNCM 3784 13200 1936 176 1452 6204 352 1804 0 0 28908 0.185971
No description has been provided for this image
MFT A B C D E F H I J K Totals Percentages
0 CM 1902428 2233836 2078956 1265704 2071740 1883552 1648812 1425644 428824 230252 15169748 99.946659
1 eSNCM 0 0 0 0 0 0 0 0 0 1452 1452 0.009567
2 pSNCM 0 176 2904 2904 88 0 176 176 88 132 6644 0.043774
No description has been provided for this image
MFT A B C D E F H I J K Totals Percentages
0 CM 2773056 3616976 2259972 1532564 1260468 1545720 1485616 1195920 1192136 352792 17215220 99.956824
2 pSNCM 792 2156 2904 1056 0 352 0 0 88 88 7436 0.043176

3. For just the dinoflagellates, what fraction are phyto vs mixo vs heterotrophs?¶

All of the dinoflagellates that are in the genus Protoperidinium are strict heterotrophs. They only use phagocytosis for nutrition and are not capable of photosynthesis. They get counted in these kinds of monitoring programs just because the person doing the counting sees them but they are not phytoplankton at all.¶

In [14]:
def trophic_strategy_for_dinoflagellates_pie(csv_name):
    # Get year
    year = re.search(r'\b(\d{4})\b', csv_name).group(1) if re.search(r'\b(\d{4})\b', csv_name) else 'Year not found'

    # Clean Data
    classified = Classifier(csv_name)
    df = classified.all_classified
    df = df.loc[df['Phylum'] == 'Dinoflagellate']
    df.loc[df['Genus']=='Protoperidinium', 'Status'] = 'Protozooplankton'
    df = df.replace('No', 'Phytoplankton')
    df = df.replace('Yes', 'Mixoplankton')
    counts = percentages(df, 'Status')
    
    # Pie Chart
    plt.title(f"Trophic Strategy of Dinoflagellates in LIS in {year}")
    plt.pie(counts['Percentages'], labels=counts['Status'], autopct='%1.3f%%')
    plt.legend(bbox_to_anchor=(.2, 1))
    
    plt.show()
    display(counts)
In [15]:
for csv_name in csvs:
    # Get pie chart for each year
    trophic_strategy_for_dinoflagellates_pie(csv_name)
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 2663104 37.790295
1 Phytoplankton 4345894 61.669622
2 Protozooplankton 38060 0.540084
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 3659608 35.202836
1 Phytoplankton 6730316 64.740872
2 Protozooplankton 5852 0.056292
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 1666984 37.969914
1 Phytoplankton 2721840 61.997013
2 Protozooplankton 1452 0.033073
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 5965212 72.606092
1 Phytoplankton 2249192 27.376234
2 Protozooplankton 1452 0.017673
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 2429984 46.689734
1 Phytoplankton 2771648 53.254469
2 Protozooplankton 2904 0.055797
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 4122976 52.946218
1 Phytoplankton 3566006 45.79375
2 Protozooplankton 98120 1.260032
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 2522476 26.075941
1 Phytoplankton 7145160 73.862654
2 Protozooplankton 5940 0.061404
No description has been provided for this image
Status Totals Percentages
0 Mixoplankton 1538592 40.38948
1 Phytoplankton 2270796 59.61052

4. What fraction of mixoplankton are nano size and micro size?¶

In [16]:
def mixoplankton_sizes_pie(csv_name):
    # Get year
    year = re.search(r'\b(\d{4})\b', csv_name).group(1) if re.search(r'\b(\d{4})\b', csv_name) else 'Year not found'

    # Clean data
    classified = Classifier(csv_name)
    df = classified.mixoplankton
    counts = percentages(df, 'size class')
    
    # Pie Chart
    plt.title(f"Relative Size of Mixoplankton in LIS in {year}")
    plt.pie(counts['Percentages'], labels=counts['size class'], autopct='%1.3f%%')
    plt.legend(bbox_to_anchor=(.2, 1))
    
    plt.show()
    display(counts)
In [17]:
for csv_name in csvs:
    # Get pie chart for each year
    mixoplankton_sizes_pie(csv_name)
No description has been provided for this image
size class Totals Percentages
1 micro 133320 0.442044
2 nano 30026566 99.557956
No description has been provided for this image
size class Totals Percentages
1 micro 311564 1.466635
2 nano 20931896 98.533365
No description has been provided for this image
size class Totals Percentages
1 micro 794376 9.188488
2 nano 7850964 90.811512
No description has been provided for this image
size class Totals Percentages
1 micro 133760 0.713611
2 nano 18610338 99.286389
No description has been provided for this image
size class Totals Percentages
1 micro 631312 3.328169
2 nano 18337436 96.671831
No description has been provided for this image
size class Totals Percentages
0 meso 37796 0.24315
1 micro 85976 0.553102
2 nano 15420548 99.203748
No description has been provided for this image
size class Totals Percentages
0 meso 1452 0.009567
1 micro 37972 0.25018
2 nano 15138420 99.740253
No description has been provided for this image
size class Totals Percentages
1 micro 1891252 10.981187
2 nano 15331404 89.018813

5. What proportion of the mixoplankton are dinoflagellates?¶

In [18]:
def mixoplankton_phylums_pie(csv_name):
    # Get year
    year = re.search(r'\b(\d{4})\b', csv_name).group(1) if re.search(r'\b(\d{4})\b', csv_name) else 'Year not found'

    # Clean data
    classified = Classifier(csv_name)
    df = classified.mixoplankton
    counts = percentages(df, 'Phylum')
    
    # Pie Chart
    plt.title(f"Relative Abundance of Mixoplankton Phylum in LIS in {year}")
    plt.pie(counts['Percentages'], labels=counts['Phylum'], autopct='%1.3f%%')
    plt.legend(bbox_to_anchor=(.19, 1))
    
    plt.show()
    display(counts)
In [19]:
for csv_name in csvs:
    # Get pie chart for each year
    mixoplankton_phylums_pie(csv_name)
No description has been provided for this image
Phylum Totals Percentages
0 Dinoflagellate 2663104 8.829954
1 Haptophyte 307089 1.018203
2 Ochrophyte (diatoms excluded) 27136849 89.97663
3 Raphidophyte 52844 0.175213
No description has been provided for this image
Phylum Totals Percentages
0 Dinoflagellate 3659608 17.226987
1 Haptophyte 335852 1.580967
2 Ochrophyte (diatoms excluded) 17032400 80.177146
3 Raphidophyte 215600 1.014901
No description has been provided for this image
Phylum Totals Percentages
0 Dinoflagellate 1666984 19.281879
1 Haptophyte 32252 0.373056
2 Ochrophyte (diatoms excluded) 6271452 72.541415
3 Raphidophyte 674652 7.803649
No description has been provided for this image
Phylum Totals Percentages
0 Dinoflagellate 5965212 31.824481
2 Ochrophyte (diatoms excluded) 12686618 67.683268
3 Raphidophyte 92268 0.492251
No description has been provided for this image
Phylum Totals Percentages
0 Dinoflagellate 2429984 12.810461
2 Ochrophyte (diatoms excluded) 16027660 84.495086
3 Raphidophyte 511104 2.694453
No description has been provided for this image
Phylum Totals Percentages
0 Dinoflagellate 4122976 26.524004
1 Haptophyte 330000 2.122962
2 Ochrophyte (diatoms excluded) 11042460 71.038553
3 Raphidophyte 48884 0.314481
No description has been provided for this image
Phylum Totals Percentages
0 Dinoflagellate 2522476 16.619462
1 Haptophyte 22000 0.144948
2 Ochrophyte (diatoms excluded) 12604504 83.045418
3 Raphidophyte 28864 0.190172
No description has been provided for this image
Phylum Totals Percentages
0 Dinoflagellate 1538592 8.933535
2 Ochrophyte (diatoms excluded) 13808344 80.175462
3 Raphidophyte 1875720 10.891003